package com.youlu.campus.entity.VO.req;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.metadata.BaseRowModel;
import lombok.Getter;
import lombok.Setter;
import lombok.ToString;

import java.util.Date;

/**
 * 用户报名活动导入
 */
@Getter
@Setter
@ToString
public class UserJoinActivityDataImport extends BaseRowModel {
    /**
     * 姓名,A
     */
    @ExcelProperty(value = "姓名", index = 0)
    protected String name;
    /**
     * 手机号,B
     */
    @ExcelProperty(value = "手机号", index = 1)
    private String mobile;

    /**
     * 学校/单位,C
     */
    @ExcelProperty(value = "学校/单位", index = 2)
    protected String universityName;
    /**
     * 证书名称,D
     */
    @ExcelProperty(value = "证书名称", index = 3)
    protected String caName;
    /**
     * 证书编号,E
     */
    @ExcelProperty(value = "证书编号", index = 4)
    protected String caNo;
    /**
     * 证书等级,F
     */
    @ExcelProperty(value = "证书等级", index = 5)
    protected String caLevel;
    /**
     * 活动名称,G
     */
    @ExcelProperty(value = "活动名称", index = 6)
    protected String activityName;
    /**
     * 发证时间,H
     */
    @ExcelProperty(value = "发证时间", index = 7)
    private Date recieveCaTime;
    /**
     * 组织单位,I
     */
    @ExcelProperty(value = "组织单位", index = 8)
    protected String caOrg;
    /**
     * qq,J
     */
    @ExcelProperty(value = "qq", index = 9)
    private String qq;
    /**
     * 邮箱,K
     */
    @ExcelProperty(value = "邮箱", index = 10)
    protected String email;
    /**
     * 批次,L
     */
    @ExcelProperty(value = "批次", index = 11)
    protected String batchNo;
    /**
     * 业务类型,报名,收款,M
     */
    @ExcelProperty(value = "业务类型", index = 12)
    protected String bizType;
    /**
     * 考试得分1,N
     */
    @ExcelProperty(value = "考试得分1", index = 13)
    protected Double qaScore1;
    /**
     * 考试得分2,O
     */
    @ExcelProperty(value = "考试得分2", index = 14)
    protected Double qaScore2;
    /**
     * 考试得分3,P
     */
    @ExcelProperty(value = "考试得分3", index = 15)
    protected Double qaScore3;
    /**
     * 已邀请人数,Q
     */
    @ExcelProperty(value = "已邀请人数", index = 16)
    protected String invitedNum;
    /**
     * 考试时长,R
     */
    @ExcelProperty(value = "考试时长", index = 17)
    protected String qaDuration;
    /**
     * 填写设备,S
     */
    @ExcelProperty(value = "填写设备", index = 18)
    protected String device;
    /**
     * 操作系统,T
     */
    @ExcelProperty(value = "操作系统", index = 19)
    protected String os;
    /**
     * 浏览器,U
     */
    @ExcelProperty(value = "浏览器", index = 20)
    protected String browser;
    /**
     * 填写地区,V
     */
    @ExcelProperty(value = "填写地区", index = 21)
    protected String zone;
    /**
     * IP,W
     */
    @ExcelProperty(value = "IP", index = 22)
    protected String ip;
    /**
     * OpenId,X
     */
    @ExcelProperty(value = "OpenId", index = 23)
    protected String openId;
    /**
     * 性别,Y
     */
    @ExcelProperty(value = "性别", index = 24)
    protected String gender;
    /**
     * 专业，Z
     */
    @ExcelProperty(value = "专业", index = 25)
    protected String discipline;
    /**
     * 年级,AA
     */
    @ExcelProperty(value = "年级", index = 26)
    protected String grade;
    /**
     * 收件人姓名,AB
     */
    @ExcelProperty(value = "收件人姓名", index = 27)
    protected String recieveName;
    /**
     * 收件人手机号,AC
     */
    @ExcelProperty(value = "收件人姓名", index = 28)
    protected String recieveMobile;
    /**
     * 收件人地址,AD
     */
    @ExcelProperty(value = "收件人地址", index = 29)
    protected String recieveAddress;
    /**
     * 证书版本,AE
     */
    @ExcelProperty(value = "证书版本", index = 30)
    protected String caEdition;
    /**
     * 证书价格,AF
     */
    @ExcelProperty(value = "证书价格", index = 31)
    protected Double caPrice;
    /**
     * 勋章类型,AG
     */
    @ExcelProperty(value = "勋章类型", index = 32)
    protected String medalType;
    /**
     * 勋章价格,AH
     */
    @ExcelProperty(value = "勋章价格", index = 33)
    protected Double medalPrice;
    /**
     * 订单金额,AI
     */
    @ExcelProperty(value = "订单金额", index = 34)
    protected Double payFee;
    /**
     * 订单状态,AJ
     */
    @ExcelProperty(value = "订单状态", index = 35)
    protected String orderStatus;
    /**
     * 支付时间,AL
     */
    @ExcelProperty(value = "支付时间", index = 37)
    protected Date payTime;
    /**
     * 支付方式,AM
     */
    @ExcelProperty(value = "支付方式", index = 38)
    protected String payWay;
    /**
     * 是否王卡,AO
     */
    @ExcelProperty(value = "是否王卡", index = 40)
    protected String isWangKa;
    /**
     * 王卡类型,AP
     */
    @ExcelProperty(value = "王卡类型", index = 41)
    protected String wangkaType;
    /**
     * 王卡剩余次数,AQ
     */
    @ExcelProperty(value = "王卡剩余次数", index = 42)
    protected String wangkaShenyu;
    /**
     * 退款金额,AR
     */
    @ExcelProperty(value = "退款金额", index = 43)
    protected Integer refundFee;
    /**
     * 退款时间,AS
     */
    @ExcelProperty(value = "退款时间", index = 44)
    protected Date refundTime;
    /**
     * 参与活动次数,AT
     */
    @ExcelProperty(value = "参与活动次数", index = 45)
    protected Integer activityNum;
    /**
     * 物流公司,AU
     */
    @ExcelProperty(value = "物流公司", index = 46)
    private String logisticsCompany;
    /**
     * 物流编号,AV
     */
    @ExcelProperty(value = "物流编号", index = 47)
    private String logisticsNo;
    /**
     * 微信交易号,AW
     */
    @ExcelProperty(value = "微信交易号", index = 48)
    private String transactionId;
    /**
     * 平台,AX
     */
    @ExcelProperty(value = "平台", index = 49)
    private String platform;
    /**
     * 邮费,AY
     */
    @ExcelProperty(value = "邮费", index = 50)
    private Double expressFee;
    /**
     * 来源:thrird:第三方,self:自有,AZ
     */
    @ExcelProperty(value = "来源", index = 51)
    private String from;
}
